EXPIRY DATE REMINDER: (Using Excel Formula) by SUSANTA CHOUDHURY

Author:SUSANTA CHOUDHURY [CHOUDHURY, SUSANTA]
Language: eng
Format: azw3
Published: 2017-10-08T04:00:00+00:00

To get today date use this formula

= ( use “=” in a cell where you want to get the result.)

=TODAY

=TODAY()

ENTER

Based on the result of remaining days we will find out final report of expiry days.

To get the “NO OF DAYS REMAIN”

=EXPIRY DATE - TODAY

=D5-F5

to get the “expiry status”

we shall use “IF” Formula and there are two condition we shall use. one condition is “if the reaming days is less then 0 day (<0) then one will display in the cell is “Expired”, if the remaining days is less then 15 (<15) then one massage will display “expiring soon”.

Here “G5” cell means “Remaining Days” So select “Remaining Days” to calculate “EXPIRY STATUS” Directly write the formula below mentioned in destination cell ( H5 ) to get the STATUS.

=IF(G5<0,“EXPIRED”,IF(G5<15,”EXPIRING SOON”,””))

or if you are new using the formula then use the formula very carefully one by one step

=

=IF

=IF(

=IF(G5

=IF(G5<0,

=IF(G5<0,“EXPIRED”

=IF(G5<0,“EXPIRED”,

=IF(G5<0,“EXPIRED”,IF

=IF(G5<0,“EXPIRED”,IF(

=IF(G5<0,“EXPIRED”,IF(G5

=IF(G5<0,“EXPIRED”,IF(G5<15,

=IF(G5<0,“EXPIRED”,IF(G5<15,”EXPIRING SOON”

=IF(G5<0,“EXPIRED”,IF(G5<15,”EXPIRING SOON”)

=IF(G5<0,“EXPIRED”,IF(G5<15,”EXPIRING SOON”,””))

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.